Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	190
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	17.9 KiB
Average record size in memory	96.7 B

Variable types

Categorical	2
Numeric	10

Alerts

`Impressions` is highly correlated with `Ad Group` and 6 other fields	High correlation
`Clicks` is highly correlated with `Ad Group` and 6 other fields	High correlation
`CTR` is highly correlated with `Ad Group`	High correlation
`Conversions` is highly correlated with `Impressions` and 5 other fields	High correlation
`Conv Rate` is highly correlated with `Ad Group`	High correlation
`Cost` is highly correlated with `Ad Group` and 6 other fields	High correlation
`CPC` is highly correlated with `Ad Group`	High correlation
`Revenue` is highly correlated with `Ad Group` and 6 other fields	High correlation
`Sale Amount` is highly correlated with `Ad Group` and 6 other fields	High correlation
`P&L` is highly correlated with `Impressions` and 5 other fields	High correlation
`Ad Group` is highly correlated with `Impressions` and 7 other fields	High correlation
`Ad Group` is uniformly distributed	Uniform
`Month` is uniformly distributed	Uniform
`Conversions` has 7 (3.7%) zeros	Zeros
`Conv Rate` has 7 (3.7%) zeros	Zeros
`Revenue` has 8 (4.2%) zeros	Zeros
`Sale Amount` has 7 (3.7%) zeros	Zeros

Reproduction

Analysis started	2022-10-16 06:05:45.986982
Analysis finished	2022-10-16 06:06:16.119965
Duration	30.13 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Ad Group
Categorical

HIGH CORRELATION
UNIFORM

Distinct	40
Distinct (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

Shop - 1:1 - Desk - [shop coupon code]	5
Shop - Phrase - Desk - Promo Code	5
Shop - Exact - Mob - Offer	5
Shop - Exact - Mob - Promo Code	5
Shop - Exact - Mob - Sale	5
Other values (35)	165

Length

Max length	47
Median length	38
Mean length	32.64210526
Min length	25

Characters and Unicode

Total characters	6202
Distinct characters	37
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	1.1%

Sample

1st row	Shop - 1:1 - Desk - [shop coupon code]
2nd row	Shop - 1:1 - Desk - [shop coupon]
3rd row	Shop - 1:1 - Desk - [shop discount code]
4th row	Shop - 1:1 - Desk - [shop promo code]
5th row	Shop - 1:1 - Desk - [shop promo]

Common Values

Value	Count	Frequency (%)
Shop - 1:1 - Desk - [shop coupon code]	5	2.6%
Shop - Phrase - Desk - Promo Code	5	2.6%
Shop - Exact - Mob - Offer	5	2.6%
Shop - Exact - Mob - Promo Code	5	2.6%
Shop - Exact - Mob - Sale	5	2.6%
Shop - Phrase - Desk - Coupon Code	5	2.6%
Shop - Phrase - Desk - Discount Code	5	2.6%
Shop - Phrase - Desk - Free Shipping	5	2.6%
Shop - Phrase - Desk - Offer	5	2.6%
Shop - Phrase - Desk - Sale	5	2.6%
Other values (30)	140	73.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	570	38.2%
shop	240	16.1%
mob	96	6.4%
desk	94	6.3%
code	90	6.0%
exact	72	4.8%
phrase	68	4.6%
1:1	50	3.3%
coupon	40	2.7%
promo	40	2.7%
Other values (9)	134	9.0%

Most occurring characters

Value	Count	Frequency (%)
	1304	21.0%
o	654	10.5%
-	570	9.2%
p	358	5.8%
e	352	5.7%
h	328	5.3%
s	242	3.9%
S	230	3.7%
r	170	2.7%
a	166	2.7%
Other values (27)	1828	29.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3330	53.7%
Space Separator	1304	21.0%
Uppercase Letter	746	12.0%
Dash Punctuation	570	9.2%
Decimal Number	100	1.6%
Other Punctuation	52	0.8%
Close Punctuation	50	0.8%
Open Punctuation	50	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	654	19.6%
p	358	10.8%
e	352	10.6%
h	328	9.8%
s	242	7.3%
r	170	5.1%
a	166	5.0%
c	154	4.6%
t	138	4.1%
d	104	3.1%
Other values (11)	664	19.9%

Uppercase Letter

Value	Count	Frequency (%)
S	230	30.8%
D	114	15.3%
C	100	13.4%
M	98	13.1%
P	88	11.8%
E	72	9.7%
F	22	2.9%
O	20	2.7%
B	2	0.3%

Other Punctuation

Value	Count	Frequency (%)
:	50	96.2%
/	2	3.8%

Space Separator

Value	Count	Frequency (%)
	1304	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	570	100.0%

Decimal Number

Value	Count	Frequency (%)
1	100	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	50	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	50	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4076	65.7%
Common	2126	34.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	654	16.0%
p	358	8.8%
e	352	8.6%
h	328	8.0%
s	242	5.9%
S	230	5.6%
r	170	4.2%
a	166	4.1%
c	154	3.8%
t	138	3.4%
Other values (20)	1284	31.5%

Common

Value	Count	Frequency (%)
	1304	61.3%
-	570	26.8%
1	100	4.7%
]	50	2.4%
[	50	2.4%
:	50	2.4%
/	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6202	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1304	21.0%
o	654	10.5%
-	570	9.2%
p	358	5.8%
e	352	5.7%
h	328	5.3%
s	242	3.9%
S	230	3.7%
r	170	2.7%
a	166	2.7%
Other values (27)	1828	29.5%

Month
Categorical

UNIFORM

Distinct	5
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

November	39
July	38
August	38
September	38
October	37

Length

Max length	9
Median length	7
Mean length	6.805263158
Min length	4

Characters and Unicode

Total characters	1293
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
November	39	20.5%
July	38	20.0%
August	38	20.0%
September	38	20.0%
October	37	19.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
november	39	20.5%
july	38	20.0%
august	38	20.0%
september	38	20.0%
october	37	19.5%

Most occurring characters

Value	Count	Frequency (%)
e	229	17.7%
b	114	8.8%
r	114	8.8%
u	114	8.8%
t	113	8.7%
m	77	6.0%
o	76	5.9%
N	39	3.0%
v	39	3.0%
s	38	2.9%
Other values (9)	340	26.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1103	85.3%
Uppercase Letter	190	14.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	229	20.8%
b	114	10.3%
r	114	10.3%
u	114	10.3%
t	113	10.2%
m	77	7.0%
o	76	6.9%
v	39	3.5%
s	38	3.4%
p	38	3.4%
Other values (4)	151	13.7%

Uppercase Letter

Value	Count	Frequency (%)
N	39	20.5%
S	38	20.0%
A	38	20.0%
J	38	20.0%
O	37	19.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1293	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	229	17.7%
b	114	8.8%
r	114	8.8%
u	114	8.8%
t	113	8.7%
m	77	6.0%
o	76	5.9%
N	39	3.0%
v	39	3.0%
s	38	2.9%
Other values (9)	340	26.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1293	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	229	17.7%
b	114	8.8%
r	114	8.8%
u	114	8.8%
t	113	8.7%
m	77	6.0%
o	76	5.9%
N	39	3.0%
v	39	3.0%
s	38	2.9%
Other values (9)	340	26.3%

Impressions
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	189
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14077.36316

Minimum	35
Maximum	276568
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	35
5-th percentile	69.25
Q1	1065
median	4969
Q3	13380
95-th percentile	56080.6
Maximum	276568
Range	276533
Interquartile range (IQR)	12315

Descriptive statistics

Standard deviation	29771.68623
Coefficient of variation (CV)	2.114862414
Kurtosis	35.80165748
Mean	14077.36316
Median Absolute Deviation (MAD)	4302
Skewness	5.173273236
Sum	2674699
Variance	886353300.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3279	2	1.1%
1770	1	0.5%
6254	1	0.5%
6908	1	0.5%
15769	1	0.5%
5044	1	0.5%
5789	1	0.5%
9619	1	0.5%
2336	1	0.5%
4715	1	0.5%
Other values (179)	179	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35	1	0.5%
36	1	0.5%
38	1	0.5%
44	1	0.5%
50	1	0.5%
52	1	0.5%
54	1	0.5%
55	1	0.5%
66	1	0.5%
67	1	0.5%

Value	Count	Frequency (%)
276568	1	0.5%
152394	1	0.5%
138811	1	0.5%
105966	1	0.5%
99258	1	0.5%
93406	1	0.5%
90806	1	0.5%
73448	1	0.5%
64067	1	0.5%
57373	1	0.5%

Clicks
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	183
Distinct (%)	96.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4865.805263

Minimum	2
Maximum	99526
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	2
5-th percentile	11.45
Q1	264.5
median	930
Q3	4190.5
95-th percentile	22736.1
Maximum	99526
Range	99524
Interquartile range (IQR)	3926

Descriptive statistics

Standard deviation	11348.52922
Coefficient of variation (CV)	2.332302385
Kurtosis	30.71189062
Mean	4865.805263
Median Absolute Deviation (MAD)	826
Skewness	4.888967218
Sum	924503
Variance	128789115.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	3	1.6%
8	2	1.1%
593	2	1.1%
123	2	1.1%
341	2	1.1%
163	2	1.1%
6504	1	0.5%
2510	1	0.5%
2908	1	0.5%
855	1	0.5%
Other values (173)	173	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	0.5%
3	1	0.5%
4	1	0.5%
5	1	0.5%
8	2	1.1%
9	3	1.6%
11	1	0.5%
12	1	0.5%
13	1	0.5%
14	1	0.5%

Value	Count	Frequency (%)
99526	1	0.5%
59177	1	0.5%
57405	1	0.5%
42283	1	0.5%
40622	1	0.5%
36068	1	0.5%
32005	1	0.5%
27121	1	0.5%
25283	1	0.5%
23538	1	0.5%

CTR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	42
Distinct (%)	22.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2721052632

Minimum	0.05
Maximum	0.47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0.05
5-th percentile	0.09
Q1	0.1925
median	0.285
Q3	0.36
95-th percentile	0.43
Maximum	0.47
Range	0.42
Interquartile range (IQR)	0.1675

Descriptive statistics

Standard deviation	0.1078936841
Coefficient of variation (CV)	0.3965145063
Kurtosis	-0.9383087548
Mean	0.2721052632
Median Absolute Deviation (MAD)	0.085
Skewness	-0.3031002304
Sum	51.7
Variance	0.01164104706
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0.34	10	5.3%
0.37	9	4.7%
0.35	8	4.2%
0.24	7	3.7%
0.25	7	3.7%
0.09	7	3.7%
0.23	7	3.7%
0.39	7	3.7%
0.26	7	3.7%
0.3	7	3.7%
Other values (32)	114	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05	1	0.5%
0.06	1	0.5%
0.07	4	2.1%
0.08	3	1.6%
0.09	7	3.7%
0.1	2	1.1%
0.11	3	1.6%
0.12	4	2.1%
0.13	4	2.1%
0.14	5	2.6%

Value	Count	Frequency (%)
0.47	2	1.1%
0.45	3	1.6%
0.44	3	1.6%
0.43	4	2.1%
0.42	1	0.5%
0.41	3	1.6%
0.4	7	3.7%
0.39	7	3.7%
0.38	5	2.6%
0.37	9	4.7%

Conversions
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	137
Distinct (%)	72.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	505.2421053

Minimum	0
Maximum	7563
Zeros	7
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	24
median	70.5
Q3	428.25
95-th percentile	2248.55
Maximum	7563
Range	7563
Interquartile range (IQR)	404.25

Descriptive statistics

Standard deviation	1052.202922
Coefficient of variation (CV)	2.082571723
Kurtosis	17.79051328
Mean	505.2421053
Median Absolute Deviation (MAD)	68.5
Skewness	3.81395678
Sum	95996
Variance	1107130.989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7	3.7%
2	5	2.6%
24	5	2.6%
1	4	2.1%
25	4	2.1%
14	4	2.1%
13	3	1.6%
3	3	1.6%
26	3	1.6%
61	3	1.6%
Other values (127)	149	78.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	3.7%
1	4	2.1%
2	5	2.6%
3	3	1.6%
4	1	0.5%
7	2	1.1%
9	1	0.5%
10	1	0.5%
11	1	0.5%
12	1	0.5%

Value	Count	Frequency (%)
7563	1	0.5%
5961	1	0.5%
5782	1	0.5%
4349	1	0.5%
4080	1	0.5%
2940	1	0.5%
2713	1	0.5%
2666	1	0.5%
2444	1	0.5%
2294	1	0.5%

Conv Rate
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	21
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.07973684211

Minimum	0
Maximum	0.5
Zeros	7
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.03
Q1	0.05
median	0.07
Q3	0.1
95-th percentile	0.14
Maximum	0.5
Range	0.5
Interquartile range (IQR)	0.05

Descriptive statistics

Standard deviation	0.05285934426
Coefficient of variation (CV)	0.6629224693
Kurtosis	23.45682501
Mean	0.07973684211
Median Absolute Deviation (MAD)	0.02
Skewness	3.592692129
Sum	15.15
Variance	0.002794110276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0.05	27	14.2%
0.07	22	11.6%
0.06	19	10.0%
0.04	19	10.0%
0.09	17	8.9%
0.1	16	8.4%
0.08	14	7.4%
0.11	12	6.3%
0.12	12	6.3%
0.03	8	4.2%
Other values (11)	24	12.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	3.7%
0.01	1	0.5%
0.03	8	4.2%
0.04	19	10.0%
0.05	27	14.2%
0.06	19	10.0%
0.07	22	11.6%
0.08	14	7.4%
0.09	17	8.9%
0.1	16	8.4%

Value	Count	Frequency (%)
0.5	1	0.5%
0.33	1	0.5%
0.28	1	0.5%
0.21	1	0.5%
0.19	1	0.5%
0.17	2	1.1%
0.15	2	1.1%
0.14	4	2.1%
0.13	3	1.6%
0.12	12	6.3%

Cost
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	175
Distinct (%)	92.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3344.063158

Minimum	1
Maximum	43542
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	188.5
median	563.5
Q3	2967
95-th percentile	13223.55
Maximum	43542
Range	43541
Interquartile range (IQR)	2778.5

Descriptive statistics

Standard deviation	6524.606753
Coefficient of variation (CV)	1.951101533
Kurtosis	15.8262848
Mean	3344.063158
Median Absolute Deviation (MAD)	557
Skewness	3.615090827
Sum	635372
Variance	42570493.29
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	4	2.1%
5	3	1.6%
1	3	1.6%
3	3	1.6%
52	2	1.1%
111	2	1.1%
8	2	1.1%
134	2	1.1%
1118	2	1.1%
272	2	1.1%
Other values (165)	165	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	1.6%
2	1	0.5%
3	3	1.6%
4	1	0.5%
5	3	1.6%
6	4	2.1%
7	1	0.5%
8	2	1.1%
18	1	0.5%
35	1	0.5%

Value	Count	Frequency (%)
43542	1	0.5%
38273	1	0.5%
37729	1	0.5%
27336	1	0.5%
24149	1	0.5%
19371	1	0.5%
18641	1	0.5%
16946	1	0.5%
13746	1	0.5%
13278	1	0.5%

CPC
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	100
Distinct (%)	52.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7912631579

Minimum	0.14
Maximum	2.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0.14
5-th percentile	0.279
Q1	0.48
median	0.635
Q3	1.1075
95-th percentile	1.4755
Maximum	2.02
Range	1.88
Interquartile range (IQR)	0.6275

Descriptive statistics

Standard deviation	0.403312323
Coefficient of variation (CV)	0.50970694
Kurtosis	-0.4407450849
Mean	0.7912631579
Median Absolute Deviation (MAD)	0.25
Skewness	0.6533200925
Sum	150.34
Variance	0.1626608299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.59	5	2.6%
0.57	5	2.6%
0.49	5	2.6%
0.62	5	2.6%
0.52	4	2.1%
0.51	4	2.1%
0.41	4	2.1%
0.48	4	2.1%
0.44	4	2.1%
0.38	4	2.1%
Other values (90)	146	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.14	1	0.5%
0.17	1	0.5%
0.19	1	0.5%
0.22	2	1.1%
0.23	2	1.1%
0.25	1	0.5%
0.26	1	0.5%
0.27	1	0.5%
0.29	1	0.5%
0.3	1	0.5%

Value	Count	Frequency (%)
2.02	1	0.5%
1.92	1	0.5%
1.87	1	0.5%
1.62	1	0.5%
1.6	1	0.5%
1.55	1	0.5%
1.51	1	0.5%
1.49	2	1.1%
1.48	1	0.5%
1.47	1	0.5%

Revenue
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	172
Distinct (%)	90.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2957.684211

Minimum	0
Maximum	42440
Zeros	8
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	5.35
Q1	144.5
median	459.5
Q3	2672.25
95-th percentile	13163
Maximum	42440
Range	42440
Interquartile range (IQR)	2527.75

Descriptive statistics

Standard deviation	5962.413097
Coefficient of variation (CV)	2.015905916
Kurtosis	17.41256614
Mean	2957.684211
Median Absolute Deviation (MAD)	451
Skewness	3.761989652
Sum	561960
Variance	35550369.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	4.2%
173	3	1.6%
165	2	1.1%
202	2	1.1%
22	2	1.1%
7	2	1.1%
76	2	1.1%
295	2	1.1%
67	2	1.1%
162	2	1.1%
Other values (162)	163	85.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	4.2%
1	1	0.5%
4	1	0.5%
7	2	1.1%
8	2	1.1%
12	1	0.5%
13	1	0.5%
14	1	0.5%
16	1	0.5%
20	1	0.5%

Value	Count	Frequency (%)
42440	1	0.5%
34518	1	0.5%
32668	1	0.5%
24071	1	0.5%
23857	1	0.5%
16555	1	0.5%
14565	1	0.5%
13744	1	0.5%
13699	1	0.5%
13262	1	0.5%

Sale Amount
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	184
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63416.18058

Minimum	0
Maximum	886095.31
Zeros	7
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	108.7105
Q1	2985.135
median	10274.105
Q3	59345.195
95-th percentile	284099.7585
Maximum	886095.31
Range	886095.31
Interquartile range (IQR)	56360.06

Descriptive statistics

Standard deviation	125414.6569
Coefficient of variation (CV)	1.97764444
Kurtosis	16.69701991
Mean	63416.18058
Median Absolute Deviation (MAD)	10072.2
Skewness	3.674198041
Sum	12049074.31
Variance	1.572883617 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7	3.7%
136770.05	1	0.5%
8585.47	1	0.5%
55815.23	1	0.5%
34980.16	1	0.5%
40122.76	1	0.5%
25311.15	1	0.5%
25104.24	1	0.5%
12245.37	1	0.5%
9859.2	1	0.5%
Other values (174)	174	91.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	3.7%
5.96	1	0.5%
28.93	1	0.5%
83.2	1	0.5%
139.89	1	0.5%
147.75	1	0.5%
157.97	1	0.5%
168.54	1	0.5%
235.27	1	0.5%
261.4	1	0.5%

Value	Count	Frequency (%)
886095.31	1	0.5%
725773.92	1	0.5%
677188.1	1	0.5%
500400.85	1	0.5%
497790.81	1	0.5%
345891.36	1	0.5%
321387.88	1	0.5%
294536.92	1	0.5%
285638.3	1	0.5%
284823.48	1	0.5%

P&L
Real number (ℝ)

HIGH CORRELATION

Distinct	188
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-386.3619158

Minimum	-5672.271
Maximum	1507.685
Zeros	0
Zeros (%)	0.0%
Negative	151
Negative (%)	79.5%
Memory size	1.6 KiB

Quantile statistics

Minimum	-5672.271
5-th percentile	-2028.99835
Q1	-294.9775
median	-75.978
Q3	-6.0275
95-th percentile	116.414
Maximum	1507.685
Range	7179.956
Interquartile range (IQR)	288.95

Descriptive statistics

Standard deviation	903.0737755
Coefficient of variation (CV)	-2.337377828
Kurtosis	14.51111736
Mean	-386.3619158
Median Absolute Deviation (MAD)	88.861
Skewness	-3.389103267
Sum	-73408.764
Variance	815542.244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	2	1.1%
-6	2	1.1%
-267.086	1	0.5%
168.373	1	0.5%
337.125	1	0.5%
-79.595	1	0.5%
342.979	1	0.5%
-265.424	1	0.5%
97.764	1	0.5%
-27.854	1	0.5%
Other values (178)	178	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5672.271	1	0.5%
-5605.297	1	0.5%
-4606.713	1	0.5%
-3478.644	1	0.5%
-3211.121	1	0.5%
-3012.91	1	0.5%
-2380.616	1	0.5%
-2240.076	1	0.5%
-2170.044	1	0.5%
-2086.3	1	0.5%

Value	Count	Frequency (%)
1507.685	1	0.5%
766.859	1	0.5%
762.921	1	0.5%
342.979	1	0.5%
337.125	1	0.5%
308.975	1	0.5%
181.597	1	0.5%
168.373	1	0.5%
117.136	1	0.5%
116.783	1	0.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Ad Group	Month	Impressions	Clicks	CTR	Conversions	Conv Rate	Cost	CPC	Revenue	Sale Amount	P&L
0	Shop - 1:1 - Desk - [shop coupon code]	July	16038	6504	0.41	1166	0.10	6669	1.03	6402	136770.05	-267.086
1	Shop - 1:1 - Desk - [shop coupon]	July	36462	14367	0.39	2188	0.09	13746	0.96	13262	283215.21	-483.951
2	Shop - 1:1 - Desk - [shop discount code]	July	3635	1458	0.40	248	0.09	1606	1.10	1723	39165.46	117.136
3	Shop - 1:1 - Desk - [shop promo code]	July	26185	10418	0.40	2294	0.12	13278	1.27	13042	284823.48	-235.921
4	Shop - 1:1 - Desk - [shop promo]	July	808	282	0.35	61	0.15	391	1.39	337	7717.77	-53.604
5	Shop - 1:1 - Mob - [shop coupon code]	July	46507	21756	0.47	1665	0.05	13157	0.60	8550	185824.49	-4606.713
6	Shop - 1:1 - Mob - [shop coupon]	July	152394	59177	0.39	2666	0.04	19371	0.33	13699	294536.92	-5672.271
7	Shop - 1:1 - Mob - [shop discount code]	July	9950	4283	0.43	347	0.05	2637	0.62	2038	46026.32	-598.993
8	Shop - 1:1 - Mob - [shop promo code]	July	57373	27121	0.47	2940	0.07	16946	0.62	14565	321387.88	-2380.616
9	Shop - 1:1 - Mob - [shop promo]	July	1875	706	0.38	69	0.07	485	0.69	409	8946.99	-75.734

Last rows

	Ad Group	Month	Impressions	Clicks	CTR	Conversions	Conv Rate	Cost	CPC	Revenue	Sale Amount	P&L
180	Shop - Phrase - Mob - Competitor	November	127	32	0.25	2	0.04	18	0.59	7	139.89	-11.005
181	Shop - Phrase - Desk - Free Shipping	November	85	9	0.11	0	0.00	2	0.32	0	0.00	-2.000
182	Shop - Phrase - Mob - Free Shipping	November	209	31	0.15	2	0.05	7	0.23	7	147.75	0.389
183	Shop - 1:1 - Mob - [shop promo]	November	5828	1975	0.34	214	0.09	1118	0.57	1121	22936.40	3.104
184	Shop - Exact - Mob - Offer	November	6838	1235	0.18	85	0.07	641	0.52	676	14020.86	34.512
185	Shop - Exact - Desk - Black Friday/Cyber Monday	November	257	24	0.09	7	0.28	3	0.14	45	898.80	41.946
186	Shop - 1:1 - Desk - [shop discount code]	November	7254	2725	0.38	512	0.11	3182	1.17	3227	66672.29	45.468
187	Shop - Exact - Desk - Coupon Code	November	18526	5553	0.30	919	0.10	5982	1.08	6047	129556.90	64.552
188	Shop - Exact - Mob - Black Friday/Cyber Monday	November	3662	266	0.07	24	0.09	44	0.17	160	3268.63	115.963
189	Shop - Exact - Desk - Promo Code	November	25592	7726	0.30	1731	0.14	10914	1.41	11223	236665.59	308.975

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Decimal Number

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows